合并单元格之前要提前将数据列排序好,然后再复制以下代码,运行宏程序。
批量合并单元格
Sub RngMergeCondition() '批量合并单元格
Dim rngUser As Range
Dim rngMerge As Range
Dim rngSelect As Range
Dim i As Long, j As Long
Dim lngRowFirst As Long
Dim lngClnFirst As Long
Dim arr As Variant
Dim brr As Variant
Dim strTemp As String
Dim lngBK As Long
Dim shtUser As Worksheet
On Error Resume Next
Set rngSelect = Selection
Set rngUser = Application.InputBox("请选择需要合并的单元格区域!", Default:=rngSelect.Address, Type:=8)
Set rngUser = Intersect(rngUser.Parent.UsedRange, rngUser)
'使用Intersect规避用户选择整列数据
If rngUser Is Nothing Then MsgBox "选择的单元格区域不能为空白": Exit Sub
arr = rngUser.Value
ReDim brr(